Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RetailStoreID (FK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | SalesMeter(AS_MTR_SLS) |
RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | FuelingPoint(AS_PNT_FUEL) |
FuelingPointID (FK)(PK) | A unique identifier for the FuelingPoint at a particular retail store | ID_PNT_FUEL | Identity | integer | FuelingPoint(AS_PNT_FUEL) |
NozzleID (PK) | A unique identifier for the Nozzle | ID_NZL | Identity | integer | |
SalesMeterID (FK) | A system-assigned unique identifier for a sales meter. | ID_MTR_SLS | Identity | integer | SalesMeter(AS_MTR_SLS) |
CurrencyID (FK) | The unique identifier of the Currency. | ID_CNY | Identity | integer | Currency(CO_CNY) |
ISOCurrencyCode (FK) | Currency code designated by ISO to identify national currency | CD_CNY_ISO_4217 | ISO_4217_CurrencyCode_char(3) | char(3) | ISO4217-CurrencyType(LU_CNY_ISO_4217) |